Accidentes Sonora Profiling Report

Dataset statistics

Number of variables	32
Number of observations	387840
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	94.7 MiB
Average record size in memory	256.0 B

Variable types

Numeric	15
Categorical	17

Alerts

`NEMUERTO` has constant value "0"	Constant
`NEHERIDO` has constant value "0"	Constant
`Municipio_Nombre` has a high cardinality: 72 distinct values	High cardinality
`Fecha_Formated` has a high cardinality: 341656 distinct values	High cardinality
`Unnamed: 0` is highly overall correlated with `ANIO` and 1 other fields	High correlation
`ID_MUNICIPIO` is highly overall correlated with `Municipio_Nombre`	High correlation
`ANIO` is highly overall correlated with `Unnamed: 0`	High correlation
`ID_EDAD` is highly overall correlated with `SEXO` and 1 other fields	High correlation
`CONDMUERTO` is highly overall correlated with `Total_Muertos`	High correlation
`CONDHERIDO` is highly overall correlated with `Total_Heridos`	High correlation
`PASAMUERTO` is highly overall correlated with `Total_Muertos`	High correlation
`PASAHERIDO` is highly overall correlated with `Total_Heridos`	High correlation
`Total_Muertos` is highly overall correlated with `CONDMUERTO` and 1 other fields	High correlation
`Total_Heridos` is highly overall correlated with `CONDHERIDO` and 1 other fields	High correlation
`URBANA` is highly overall correlated with `SUBURBANA` and 2 other fields	High correlation
`SUBURBANA` is highly overall correlated with `URBANA` and 1 other fields	High correlation
`TIPACCID` is highly overall correlated with `URBANA` and 8 other fields	High correlation
`CAUSAACCI` is highly overall correlated with `TIPACCID` and 5 other fields	High correlation
`CAPAROD` is highly overall correlated with `DIASEMANA` and 6 other fields	High correlation
`SEXO` is highly overall correlated with `TIPACCID` and 6 other fields	High correlation
`ALIENTO` is highly overall correlated with `TIPACCID` and 6 other fields	High correlation
`CINTURON` is highly overall correlated with `Unnamed: 0` and 6 other fields	High correlation
`Municipio_Nombre` is highly overall correlated with `ID_MUNICIPIO` and 8 other fields	High correlation
`PEATMUERTO` is highly overall correlated with `Total_Muertos`	High correlation
`DIASEMANA` is highly overall correlated with `CAPAROD`	High correlation
`PEATHERIDO` is highly overall correlated with `TIPACCID`	High correlation
`CICLHERIDO` is highly overall correlated with `TIPACCID`	High correlation
`PASAMUERTO` is highly skewed (γ1 = 36.22011675)	Skewed
`OTROHERIDO` is highly skewed (γ1 = 31.44966803)	Skewed
`Fecha_Formated` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`ID_HORA` has 11519 (3.0%) zeros	Zeros
`ID_EDAD` has 44618 (11.5%) zeros	Zeros
`CONDMUERTO` has 385345 (99.4%) zeros	Zeros
`CONDHERIDO` has 322149 (83.1%) zeros	Zeros
`PASAMUERTO` has 386408 (99.6%) zeros	Zeros
`PASAHERIDO` has 342606 (88.3%) zeros	Zeros
`PEATHERIDO` has 365679 (94.3%) zeros	Zeros
`OTROHERIDO` has 386332 (99.6%) zeros	Zeros
`Total_Muertos` has 382142 (98.5%) zeros	Zeros
`Total_Heridos` has 265447 (68.4%) zeros	Zeros

Reproduction

Analysis started	2022-12-12 22:23:02.794372
Analysis finished	2022-12-12 22:26:37.862736
Duration	3 minutes and 35.07 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

HIGH CORRELATION
UNIQUE

Distinct	387840
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4706519.6

Minimum	207539
Maximum	9511225
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	207539
5-th percentile	473219.95
Q1	1823126.8
median	4542037.5
Q3	7701589.2
95-th percentile	9491833.1
Maximum	9511225
Range	9303686
Interquartile range (IQR)	5878462.5

Descriptive statistics

Standard deviation	2989350.8
Coefficient of variation (CV)	0.63515105
Kurtosis	-1.3350588
Mean	4706519.6
Median Absolute Deviation (MAD)	2730997
Skewness	0.098717642
Sum	1.8253765 × 10¹²
Variance	8.9362184 × 10¹²
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
207539	1	< 0.1%
6579710	1	< 0.1%
6579719	1	< 0.1%
6579718	1	< 0.1%
6579717	1	< 0.1%
6579716	1	< 0.1%
6579715	1	< 0.1%
6579714	1	< 0.1%
6579713	1	< 0.1%
6579712	1	< 0.1%
Other values (387830)	387830	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
207539	1	< 0.1%
207540	1	< 0.1%
207541	1	< 0.1%
207542	1	< 0.1%
207543	1	< 0.1%
207544	1	< 0.1%
207545	1	< 0.1%
207546	1	< 0.1%
207547	1	< 0.1%
207548	1	< 0.1%

Value	Count	Frequency (%)
9511225	1	< 0.1%
9511224	1	< 0.1%
9511223	1	< 0.1%
9511222	1	< 0.1%
9511221	1	< 0.1%
9511220	1	< 0.1%
9511219	1	< 0.1%
9511218	1	< 0.1%
9511217	1	< 0.1%
9511216	1	< 0.1%

ID_MUNICIPIO
Real number (ℝ)

Distinct	72
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.586971

Minimum	1
Maximum	72
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	1
5-th percentile	17
Q1	18
median	30
Q3	43
95-th percentile	55
Maximum	72
Range	71
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	14.278054
Coefficient of variation (CV)	0.45202351
Kurtosis	-0.24425264
Mean	31.586971
Median Absolute Deviation (MAD)	12
Skewness	0.52653435
Sum	12250691
Variance	203.86282
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	96495	24.9%
18	74650	19.2%
55	45061	11.6%
29	30280	7.8%
43	28059	7.2%
17	27470	7.1%
48	14564	3.8%
42	14214	3.7%
2	7105	1.8%
25	6886	1.8%
Other values (62)	43056	11.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	135	< 0.1%
2	7105	1.8%
3	934	0.2%
4	1430	0.4%
5	156	< 0.1%
6	568	0.1%
7	95	< 0.1%
8	57	< 0.1%
9	127	< 0.1%
10	123	< 0.1%

Value	Count	Frequency (%)
72	1472	0.4%
71	2303	0.6%
70	1837	0.5%
69	194	0.1%
68	175	< 0.1%
67	183	< 0.1%
66	783	0.2%
65	138	< 0.1%
64	98	< 0.1%
63	105	< 0.1%

ANIO
Real number (ℝ)

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2008.7007

Minimum	1997
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	1997
5-th percentile	1998
Q1	2002
median	2008
Q3	2016
95-th percentile	2021
Maximum	2021
Range	24
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	7.387483
Coefficient of variation (CV)	0.0036777421
Kurtosis	-1.2338869
Mean	2008.7007
Median Absolute Deviation (MAD)	6
Skewness	0.13193145
Sum	7.7905447 × 10⁸
Variance	54.574905
Monotonicity	Increasing

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
2021	21209	5.5%
2006	18644	4.8%
2005	18119	4.7%
2001	17642	4.5%
2007	17372	4.5%
2004	17321	4.5%
2019	17074	4.4%
1998	16955	4.4%
2000	16811	4.3%
2002	16749	4.3%
Other values (15)	209944	54.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1997	15499	4.0%
1998	16955	4.4%
1999	15799	4.1%
2000	16811	4.3%
2001	17642	4.5%
2002	16749	4.3%
2003	16627	4.3%
2004	17321	4.5%
2005	18119	4.7%
2006	18644	4.8%

Value	Count	Frequency (%)
2021	21209	5.5%
2020	13362	3.4%
2019	17074	4.4%
2018	16369	4.2%
2017	15927	4.1%
2016	13145	3.4%
2015	11960	3.1%
2014	12604	3.2%
2013	10451	2.7%
2012	11945	3.1%

MES
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.6294761

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4687015
Coefficient of variation (CV)	0.52322408
Kurtosis	-1.2217945
Mean	6.6294761
Median Absolute Deviation (MAD)	3
Skewness	-0.023430939
Sum	2571176
Variance	12.03189
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	37170	9.6%
5	33637	8.7%
10	33554	8.7%
3	33337	8.6%
6	33013	8.5%
11	32692	8.4%
9	31592	8.1%
7	31466	8.1%
8	30986	8.0%
4	30358	7.8%
Other values (2)	60035	15.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	30270	7.8%
2	29765	7.7%
3	33337	8.6%
4	30358	7.8%
5	33637	8.7%
6	33013	8.5%
7	31466	8.1%
8	30986	8.0%
9	31592	8.1%
10	33554	8.7%

Value	Count	Frequency (%)
12	37170	9.6%
11	32692	8.4%
10	33554	8.7%
9	31592	8.1%
8	30986	8.0%
7	31466	8.1%
6	33013	8.5%
5	33637	8.7%
4	30358	7.8%
3	33337	8.6%

ID_HORA
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.220001

Minimum	0
Maximum	23
Zeros	11519
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	14
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.2857556
Coefficient of variation (CV)	0.47547317
Kurtosis	-0.73017319
Mean	13.220001
Median Absolute Deviation (MAD)	5
Skewness	-0.4350823
Sum	5127245
Variance	39.510723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
18	25001	6.4%
17	23832	6.1%
19	22869	5.9%
13	22201	5.7%
14	22188	5.7%
16	22171	5.7%
15	21715	5.6%
20	20705	5.3%
12	19468	5.0%
11	17078	4.4%
Other values (14)	170612	44.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11519	3.0%
1	10427	2.7%
2	10958	2.8%
3	9535	2.5%
4	6529	1.7%
5	5067	1.3%
6	8382	2.2%
7	13653	3.5%
8	16229	4.2%
9	14690	3.8%

Value	Count	Frequency (%)
23	15040	3.9%
22	15488	4.0%
21	16762	4.3%
20	20705	5.3%
19	22869	5.9%
18	25001	6.4%
17	23832	6.1%
16	22171	5.7%
15	21715	5.6%
14	22188	5.7%

ID_DIA
Real number (ℝ)

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.580531

Minimum	0
Maximum	32
Zeros	431
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	29
Maximum	32
Range	32
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8070287
Coefficient of variation (CV)	0.56525858
Kurtosis	-1.1732797
Mean	15.580531
Median Absolute Deviation (MAD)	8
Skewness	0.016990815
Sum	6042753
Variance	77.563754
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
15	16558	4.3%
1	14780	3.8%
28	13511	3.5%
14	12926	3.3%
16	12924	3.3%
2	12763	3.3%
25	12744	3.3%
3	12697	3.3%
8	12676	3.3%
17	12671	3.3%
Other values (23)	253590	65.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	431	0.1%
1	14780	3.8%
2	12763	3.3%
3	12697	3.3%
4	12629	3.3%
5	12342	3.2%
6	12565	3.2%
7	12364	3.2%
8	12676	3.3%
9	12413	3.2%

Value	Count	Frequency (%)
32	2	< 0.1%
31	7196	1.9%
30	11452	3.0%
29	11431	2.9%
28	13511	3.5%
27	11968	3.1%
26	12000	3.1%
25	12744	3.3%
24	12225	3.2%
23	12258	3.2%

DIASEMANA
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Sábado	70220
Domingo	70205
Viernes	56146
Lunes	52248
Jueves	47393
Other values (4)	91628

Length

Max length	16
Median length	15
Mean length	6.5544606
Min length	5

Characters and Unicode

Total characters	2542082
Distinct characters	29
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Viernes
2nd row	Miércoles
3rd row	Jueves
4th row	Martes
5th row	Lunes

Common Values

Value	Count	Frequency (%)
Sábado	70220	18.1%
Domingo	70205	18.1%
Viernes	56146	14.5%
Lunes	52248	13.5%
Jueves	47393	12.2%
Martes	45658	11.8%
Miércoles	45537	11.7%
Certificado cero	431	0.1%
No especificado	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sábado	70220	18.1%
domingo	70205	18.1%
viernes	56146	14.5%
lunes	52248	13.5%
jueves	47393	12.2%
martes	45658	11.8%
miércoles	45537	11.7%
certificado	431	0.1%
cero	431	0.1%
no	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	351387	13.8%
o	257033	10.1%
s	246984	9.7%
n	178599	7.0%
i	172754	6.8%
r	148203	5.8%
a	116311	4.6%
u	99641	3.9%
M	91195	3.6%
d	70653	2.8%
Other values (19)	809322	31.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2153809	84.7%
Uppercase Letter	387840	15.3%
Space Separator	433	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	351387	16.3%
o	257033	11.9%
s	246984	11.5%
n	178599	8.3%
i	172754	8.0%
r	148203	6.9%
a	116311	5.4%
u	99641	4.6%
d	70653	3.3%
á	70220	3.3%
Other values (10)	442024	20.5%

Uppercase Letter

Value	Count	Frequency (%)
M	91195	23.5%
S	70220	18.1%
D	70205	18.1%
V	56146	14.5%
L	52248	13.5%
J	47393	12.2%
C	431	0.1%
N	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	433	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2541649	> 99.9%
Common	433	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	351387	13.8%
o	257033	10.1%
s	246984	9.7%
n	178599	7.0%
i	172754	6.8%
r	148203	5.8%
a	116311	4.6%
u	99641	3.9%
M	91195	3.6%
d	70653	2.8%
Other values (18)	808889	31.8%

Common

Value	Count	Frequency (%)
	433	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2426325	95.4%
None	115757	4.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	351387	14.5%
o	257033	10.6%
s	246984	10.2%
n	178599	7.4%
i	172754	7.1%
r	148203	6.1%
a	116311	4.8%
u	99641	4.1%
M	91195	3.8%
d	70653	2.9%
Other values (17)	693565	28.6%

None

Value	Count	Frequency (%)
á	70220	60.7%
é	45537	39.3%

URBANA
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Accidente en intersección	299612
Accidente en no intersección	53408
Sin accidente en esta zona	34820

Length

Max length	28
Median length	25
Mean length	25.502898
Min length	25

Characters and Unicode

Total characters	9891044
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sin accidente en esta zona
2nd row	Sin accidente en esta zona
3rd row	Sin accidente en esta zona
4th row	Accidente en no intersección
5th row	Accidente en intersección

Common Values

Value	Count	Frequency (%)
Accidente en intersección	299612	77.3%
Accidente en no intersección	53408	13.8%
Sin accidente en esta zona	34820	9.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
accidente	387840	30.1%
en	387840	30.1%
intersección	353020	27.4%
no	53408	4.2%
sin	34820	2.7%
esta	34820	2.7%
zona	34820	2.7%

Most occurring characters

Value	Count	Frequency (%)
e	1904380	19.3%
n	1604768	16.2%
c	1481720	15.0%
i	1128700	11.4%
	898728	9.1%
t	775680	7.8%
d	387840	3.9%
s	387840	3.9%
A	353020	3.6%
r	353020	3.6%
Other values (5)	615348	6.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8604476	87.0%
Space Separator	898728	9.1%
Uppercase Letter	387840	3.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1904380	22.1%
n	1604768	18.7%
c	1481720	17.2%
i	1128700	13.1%
t	775680	9.0%
d	387840	4.5%
s	387840	4.5%
r	353020	4.1%
ó	353020	4.1%
a	104460	1.2%
Other values (2)	123048	1.4%

Uppercase Letter

Value	Count	Frequency (%)
A	353020	91.0%
S	34820	9.0%

Space Separator

Value	Count	Frequency (%)
	898728	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8992316	90.9%
Common	898728	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1904380	21.2%
n	1604768	17.8%
c	1481720	16.5%
i	1128700	12.6%
t	775680	8.6%
d	387840	4.3%
s	387840	4.3%
A	353020	3.9%
r	353020	3.9%
ó	353020	3.9%
Other values (4)	262328	2.9%

Common

Value	Count	Frequency (%)
	898728	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9538024	96.4%
None	353020	3.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1904380	20.0%
n	1604768	16.8%
c	1481720	15.5%
i	1128700	11.8%
	898728	9.4%
t	775680	8.1%
d	387840	4.1%
s	387840	4.1%
A	353020	3.7%
r	353020	3.7%
Other values (4)	262328	2.8%

None

Value	Count	Frequency (%)
ó	353020	100.0%

SUBURBANA
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Sin accidente en esta zona	354836
Accidente en camino rural	15712
Accidente en carretera estatal	13121
Accidentes en otro camino	4171

Length

Max length	30
Median length	26
Mean length	26.084058
Min length	25

Characters and Unicode

Total characters	10116441
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Accidente en carretera estatal
2nd row	Accidente en camino rural
3rd row	Accidente en camino rural
4th row	Sin accidente en esta zona
5th row	Sin accidente en esta zona

Common Values

Value	Count	Frequency (%)
Sin accidente en esta zona	354836	91.5%
Accidente en camino rural	15712	4.1%
Accidente en carretera estatal	13121	3.4%
Accidentes en otro camino	4171	1.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
en	387840	20.3%
accidente	383669	20.1%
sin	354836	18.6%
esta	354836	18.6%
zona	354836	18.6%
camino	19883	1.0%
rural	15712	0.8%
carretera	13121	0.7%
estatal	13121	0.7%
accidentes	4171	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	1557719	15.4%
	1518356	15.0%
n	1505235	14.9%
a	1152587	11.4%
c	808684	8.0%
t	786210	7.8%
i	762559	7.5%
d	387840	3.8%
o	383061	3.8%
s	372128	3.7%
Other values (7)	882062	8.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8210245	81.2%
Space Separator	1518356	15.0%
Uppercase Letter	387840	3.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1557719	19.0%
n	1505235	18.3%
a	1152587	14.0%
c	808684	9.8%
t	786210	9.6%
i	762559	9.3%
d	387840	4.7%
o	383061	4.7%
s	372128	4.5%
z	354836	4.3%
Other values (4)	139386	1.7%

Uppercase Letter

Value	Count	Frequency (%)
S	354836	91.5%
A	33004	8.5%

Space Separator

Value	Count	Frequency (%)
	1518356	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8598085	85.0%
Common	1518356	15.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1557719	18.1%
n	1505235	17.5%
a	1152587	13.4%
c	808684	9.4%
t	786210	9.1%
i	762559	8.9%
d	387840	4.5%
o	383061	4.5%
s	372128	4.3%
S	354836	4.1%
Other values (6)	527226	6.1%

Common

Value	Count	Frequency (%)
	1518356	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10116441	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1557719	15.4%
	1518356	15.0%
n	1505235	14.9%
a	1152587	11.4%
c	808684	8.0%
t	786210	7.8%
i	762559	7.5%
d	387840	3.8%
o	383061	3.8%
s	372128	3.7%
Other values (7)	882062	8.7%

TIPACCID
Categorical

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Colisión con vehículo automotor	255587
Colisión con objeto fijo	44410
Colisión con peatón (atropellamiento)	22067
Colisión con motocicleta	20390
Volcadura	13726
Other values (8)	31660

Length

Max length	37
Median length	31
Mean length	28.26537
Min length	4

Characters and Unicode

Total characters	10962441
Distinct characters	29
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Colisión con vehículo automotor
2nd row	Volcadura
3rd row	Colisión con animal
4th row	Colisión con objeto fijo
5th row	Colisión con objeto fijo

Common Values

Value	Count	Frequency (%)
Colisión con vehículo automotor	255587	65.9%
Colisión con objeto fijo	44410	11.5%
Colisión con peatón (atropellamiento)	22067	5.7%
Colisión con motocicleta	20390	5.3%
Volcadura	13726	3.5%
Colisión con ciclista	10244	2.6%
Salida del camino	9330	2.4%
Caída de pasajero	4450	1.1%
Otro	2929	0.8%
Colisión con animal	2513	0.6%
Other values (3)	2194	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
colisión	355405	24.5%
con	355405	24.5%
vehículo	255587	17.6%
automotor	255587	17.6%
objeto	44410	3.1%
fijo	44410	3.1%
peatón	22067	1.5%
atropellamiento	22067	1.5%
motocicleta	20390	1.4%
volcadura	13726	0.9%
Other values (13)	61036	4.2%

Most occurring characters

Value	Count	Frequency (%)
o	1985747	18.1%
	1062250	9.7%
i	843348	7.7%
n	767155	7.0%
l	720853	6.6%
c	699326	6.4%
t	677554	6.2%
u	524900	4.8%
a	432700	3.9%
e	408828	3.7%
Other values (19)	2839780	25.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9468217	86.4%
Space Separator	1062250	9.7%
Uppercase Letter	387840	3.5%
Open Punctuation	22067	0.2%
Close Punctuation	22067	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1985747	21.0%
i	843348	8.9%
n	767155	8.1%
l	720853	7.6%
c	699326	7.4%
t	677554	7.2%
u	524900	5.5%
a	432700	4.6%
e	408828	4.3%
ó	377472	4.0%
Other values (11)	2030334	21.4%

Uppercase Letter

Value	Count	Frequency (%)
C	361671	93.3%
V	13726	3.5%
S	9330	2.4%
O	2929	0.8%
I	184	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1062250	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	22067	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	22067	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9856057	89.9%
Common	1106384	10.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1985747	20.1%
i	843348	8.6%
n	767155	7.8%
l	720853	7.3%
c	699326	7.1%
t	677554	6.9%
u	524900	5.3%
a	432700	4.4%
e	408828	4.1%
ó	377472	3.8%
Other values (16)	2418174	24.5%

Common

Value	Count	Frequency (%)
	1062250	96.0%
(	22067	2.0%
)	22067	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10324932	94.2%
None	637509	5.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1985747	19.2%
	1062250	10.3%
i	843348	8.2%
n	767155	7.4%
l	720853	7.0%
c	699326	6.8%
t	677554	6.6%
u	524900	5.1%
a	432700	4.2%
e	408828	4.0%
Other values (17)	2202271	21.3%

None

Value	Count	Frequency (%)
ó	377472	59.2%
í	260037	40.8%

CAUSAACCI
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Conductor	307451
Otra	63302
Falla del vehículo	5512
Mala condición del camino	4894
Peatón o pasajero	4865

Length

Max length	25
Median length	9
Mean length	8.6468492
Min length	4

Characters and Unicode

Total characters	3353594
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Conductor
2nd row	Conductor
3rd row	Otra
4th row	Conductor
5th row	Conductor

Common Values

Value	Count	Frequency (%)
Conductor	307451	79.3%
Otra	63302	16.3%
Falla del vehículo	5512	1.4%
Mala condición del camino	4894	1.3%
Peatón o pasajero	4865	1.3%
Certificado cero	1816	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
conductor	307451	72.3%
otra	63302	14.9%
del	10406	2.4%
falla	5512	1.3%
vehículo	5512	1.3%
mala	4894	1.2%
condición	4894	1.2%
camino	4894	1.2%
peatón	4865	1.1%
o	4865	1.1%
Other values (3)	8497	2.0%

Most occurring characters

Value	Count	Frequency (%)
o	643564	19.2%
r	379250	11.3%
t	377434	11.3%
c	331277	9.9%
n	326998	9.8%
d	324567	9.7%
u	312963	9.3%
C	309267	9.2%
a	105419	3.1%
O	63302	1.9%
Other values (16)	179553	5.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2928502	87.3%
Uppercase Letter	387840	11.6%
Space Separator	37252	1.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	643564	22.0%
r	379250	13.0%
t	377434	12.9%
c	331277	11.3%
n	326998	11.2%
d	324567	11.1%
u	312963	10.7%
a	105419	3.6%
l	31836	1.1%
e	29280	1.0%
Other values (10)	65914	2.3%

Uppercase Letter

Value	Count	Frequency (%)
C	309267	79.7%
O	63302	16.3%
F	5512	1.4%
M	4894	1.3%
P	4865	1.3%

Space Separator

Value	Count	Frequency (%)
	37252	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3316342	98.9%
Common	37252	1.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	643564	19.4%
r	379250	11.4%
t	377434	11.4%
c	331277	10.0%
n	326998	9.9%
d	324567	9.8%
u	312963	9.4%
C	309267	9.3%
a	105419	3.2%
O	63302	1.9%
Other values (15)	142301	4.3%

Common

Value	Count	Frequency (%)
	37252	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3338323	99.5%
None	15271	0.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	643564	19.3%
r	379250	11.4%
t	377434	11.3%
c	331277	9.9%
n	326998	9.8%
d	324567	9.7%
u	312963	9.4%
C	309267	9.3%
a	105419	3.2%
O	63302	1.9%
Other values (14)	164282	4.9%

None

Value	Count	Frequency (%)
ó	9759	63.9%
í	5512	36.1%

CAPAROD
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Pavimentada	353423
No Pavimentada	32601
Certificado cero	1816

Length

Max length	16
Median length	11
Mean length	11.275585
Min length	11

Characters and Unicode

Total characters	4373123
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pavimentada
2nd row	No Pavimentada
3rd row	No Pavimentada
4th row	No Pavimentada
5th row	No Pavimentada

Common Values

Value	Count	Frequency (%)
Pavimentada	353423	91.1%
No Pavimentada	32601	8.4%
Certificado cero	1816	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pavimentada	386024	91.4%
no	32601	7.7%
certificado	1816	0.4%
cero	1816	0.4%

Most occurring characters

Value	Count	Frequency (%)
a	1159888	26.5%
i	389656	8.9%
e	389656	8.9%
t	387840	8.9%
d	387840	8.9%
P	386024	8.8%
v	386024	8.8%
m	386024	8.8%
n	386024	8.8%
o	36233	0.8%
Other values (6)	77914	1.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3918265	89.6%
Uppercase Letter	420441	9.6%
Space Separator	34417	0.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1159888	29.6%
i	389656	9.9%
e	389656	9.9%
t	387840	9.9%
d	387840	9.9%
v	386024	9.9%
m	386024	9.9%
n	386024	9.9%
o	36233	0.9%
r	3632	0.1%
Other values (2)	5448	0.1%

Uppercase Letter

Value	Count	Frequency (%)
P	386024	91.8%
N	32601	7.8%
C	1816	0.4%

Space Separator

Value	Count	Frequency (%)
	34417	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4338706	99.2%
Common	34417	0.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1159888	26.7%
i	389656	9.0%
e	389656	9.0%
t	387840	8.9%
d	387840	8.9%
P	386024	8.9%
v	386024	8.9%
m	386024	8.9%
n	386024	8.9%
o	36233	0.8%
Other values (5)	43497	1.0%

Common

Value	Count	Frequency (%)
	34417	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4373123	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1159888	26.5%
i	389656	8.9%
e	389656	8.9%
t	387840	8.9%
d	387840	8.9%
P	386024	8.8%
v	386024	8.8%
m	386024	8.8%
n	386024	8.8%
o	36233	0.8%
Other values (6)	77914	1.8%

SEXO
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Hombre	289419
Mujer	54141
Se fugó	42464
Certificado cero	1816

Length

Max length	16
Median length	6
Mean length	6.0167157
Min length	5

Characters and Unicode

Total characters	2333523
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hombre
2nd row	Se fugó
3rd row	Hombre
4th row	Se fugó
5th row	Hombre

Common Values

Value	Count	Frequency (%)
Hombre	289419	74.6%
Mujer	54141	14.0%
Se fugó	42464	10.9%
Certificado cero	1816	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hombre	289419	67.0%
mujer	54141	12.5%
se	42464	9.8%
fugó	42464	9.8%
certificado	1816	0.4%
cero	1816	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	389656	16.7%
r	347192	14.9%
o	293051	12.6%
H	289419	12.4%
m	289419	12.4%
b	289419	12.4%
u	96605	4.1%
M	54141	2.3%
j	54141	2.3%
f	44280	1.9%
Other values (10)	186200	8.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1901403	81.5%
Uppercase Letter	387840	16.6%
Space Separator	44280	1.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	389656	20.5%
r	347192	18.3%
o	293051	15.4%
m	289419	15.2%
b	289419	15.2%
u	96605	5.1%
j	54141	2.8%
f	44280	2.3%
g	42464	2.2%
ó	42464	2.2%
Other values (5)	12712	0.7%

Uppercase Letter

Value	Count	Frequency (%)
H	289419	74.6%
M	54141	14.0%
S	42464	10.9%
C	1816	0.5%

Space Separator

Value	Count	Frequency (%)
	44280	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2289243	98.1%
Common	44280	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	389656	17.0%
r	347192	15.2%
o	293051	12.8%
H	289419	12.6%
m	289419	12.6%
b	289419	12.6%
u	96605	4.2%
M	54141	2.4%
j	54141	2.4%
f	44280	1.9%
Other values (9)	141920	6.2%

Common

Value	Count	Frequency (%)
	44280	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2291059	98.2%
None	42464	1.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	389656	17.0%
r	347192	15.2%
o	293051	12.8%
H	289419	12.6%
m	289419	12.6%
b	289419	12.6%
u	96605	4.2%
M	54141	2.4%
j	54141	2.4%
f	44280	1.9%
Other values (9)	143736	6.3%

None

Value	Count	Frequency (%)
ó	42464	100.0%

ALIENTO
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

No	237627
Se ignora	95239
Sí	53158
Certificado cero	1816

Length

Max length	16
Median length	2
Mean length	3.784491
Min length	2

Characters and Unicode

Total characters	1467777
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Se ignora
2nd row	Se ignora
3rd row	No
4th row	Se ignora
5th row	Se ignora

Common Values

Value	Count	Frequency (%)
No	237627	61.3%
Se ignora	95239	24.6%
Sí	53158	13.7%
Certificado cero	1816	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	237627	49.0%
se	95239	19.6%
ignora	95239	19.6%
sí	53158	11.0%
certificado	1816	0.4%
cero	1816	0.4%

Most occurring characters

Value	Count	Frequency (%)
o	336498	22.9%
N	237627	16.2%
S	148397	10.1%
e	98871	6.7%
i	98871	6.7%
r	98871	6.7%
	97055	6.6%
a	97055	6.6%
g	95239	6.5%
n	95239	6.5%
Other values (6)	64054	4.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	982882	67.0%
Uppercase Letter	387840	26.4%
Space Separator	97055	6.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	336498	34.2%
e	98871	10.1%
i	98871	10.1%
r	98871	10.1%
a	97055	9.9%
g	95239	9.7%
n	95239	9.7%
í	53158	5.4%
c	3632	0.4%
t	1816	0.2%
Other values (2)	3632	0.4%

Uppercase Letter

Value	Count	Frequency (%)
N	237627	61.3%
S	148397	38.3%
C	1816	0.5%

Space Separator

Value	Count	Frequency (%)
	97055	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1370722	93.4%
Common	97055	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	336498	24.5%
N	237627	17.3%
S	148397	10.8%
e	98871	7.2%
i	98871	7.2%
r	98871	7.2%
a	97055	7.1%
g	95239	6.9%
n	95239	6.9%
í	53158	3.9%
Other values (5)	10896	0.8%

Common

Value	Count	Frequency (%)
	97055	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1414619	96.4%
None	53158	3.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	336498	23.8%
N	237627	16.8%
S	148397	10.5%
e	98871	7.0%
i	98871	7.0%
r	98871	7.0%
	97055	6.9%
a	97055	6.9%
g	95239	6.7%
n	95239	6.7%
Other values (5)	10896	0.8%

None

Value	Count	Frequency (%)
í	53158	100.0%

CINTURON
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Se ignora	219064
No	97002
Sí	69958
Certificado cero	1816

Length

Max length	16
Median length	9
Mean length	6.0193688
Min length	2

Characters and Unicode

Total characters	2334552
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Se ignora
2nd row	Se ignora
3rd row	Se ignora
4th row	Se ignora
5th row	Se ignora

Common Values

Value	Count	Frequency (%)
Se ignora	219064	56.5%
No	97002	25.0%
Sí	69958	18.0%
Certificado cero	1816	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
se	219064	36.0%
ignora	219064	36.0%
no	97002	15.9%
sí	69958	11.5%
certificado	1816	0.3%
cero	1816	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	319698	13.7%
S	289022	12.4%
e	222696	9.5%
i	222696	9.5%
r	222696	9.5%
	220880	9.5%
a	220880	9.5%
g	219064	9.4%
n	219064	9.4%
N	97002	4.2%
Other values (6)	80854	3.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1725832	73.9%
Uppercase Letter	387840	16.6%
Space Separator	220880	9.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	319698	18.5%
e	222696	12.9%
i	222696	12.9%
r	222696	12.9%
a	220880	12.8%
g	219064	12.7%
n	219064	12.7%
í	69958	4.1%
c	3632	0.2%
t	1816	0.1%
Other values (2)	3632	0.2%

Uppercase Letter

Value	Count	Frequency (%)
S	289022	74.5%
N	97002	25.0%
C	1816	0.5%

Space Separator

Value	Count	Frequency (%)
	220880	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2113672	90.5%
Common	220880	9.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	319698	15.1%
S	289022	13.7%
e	222696	10.5%
i	222696	10.5%
r	222696	10.5%
a	220880	10.5%
g	219064	10.4%
n	219064	10.4%
N	97002	4.6%
í	69958	3.3%
Other values (5)	10896	0.5%

Common

Value	Count	Frequency (%)
	220880	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2264594	97.0%
None	69958	3.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	319698	14.1%
S	289022	12.8%
e	222696	9.8%
i	222696	9.8%
r	222696	9.8%
	220880	9.8%
a	220880	9.8%
g	219064	9.7%
n	219064	9.7%
N	97002	4.3%
Other values (5)	10896	0.5%

None

Value	Count	Frequency (%)
í	69958	100.0%

ID_EDAD
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	88
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.306363

Minimum	0
Maximum	99
Zeros	44618
Zeros (%)	11.5%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	18
median	26
Q3	39
95-th percentile	64
Maximum	99
Range	99
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	19.384586
Coefficient of variation (CV)	0.6614463
Kurtosis	2.2141281
Mean	29.306363
Median Absolute Deviation (MAD)	8
Skewness	1.0961063
Sum	11366180
Variance	375.76216
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	72086	18.6%
0	44618	11.5%
25	9716	2.5%
28	9693	2.5%
23	9421	2.4%
22	9336	2.4%
30	9016	2.3%
26	8840	2.3%
24	8810	2.3%
21	8762	2.3%
Other values (78)	197542	50.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	44618	11.5%
12	443	0.1%
13	387	0.1%
14	840	0.2%
15	1739	0.4%
16	2948	0.8%
17	5167	1.3%
18	72086	18.6%
19	8023	2.1%
20	8653	2.2%

Value	Count	Frequency (%)
99	8285	2.1%
98	1	< 0.1%
96	2	< 0.1%
95	2	< 0.1%
94	3	< 0.1%
93	4	< 0.1%
92	5	< 0.1%
91	6	< 0.1%
90	13	< 0.1%
89	23	< 0.1%

CONDMUERTO
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0066625413

Minimum	0
Maximum	7
Zeros	385345
Zeros (%)	99.4%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.085009816
Coefficient of variation (CV)	12.759368
Kurtosis	345.97869
Mean	0.0066625413
Median Absolute Deviation (MAD)	0
Skewness	14.940908
Sum	2584
Variance	0.0072266688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	385345	99.4%
1	2421	0.6%
2	66	< 0.1%
3	5	< 0.1%
4	1	< 0.1%
7	1	< 0.1%
5	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	385345	99.4%
1	2421	0.6%
2	66	< 0.1%
3	5	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
5	1	< 0.1%
4	1	< 0.1%
3	5	< 0.1%
2	66	< 0.1%
1	2421	0.6%
0	385345	99.4%

CONDHERIDO
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.18472566

Minimum	0
Maximum	30
Zeros	322149
Zeros (%)	83.1%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	30
Range	30
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.43017411
Coefficient of variation (CV)	2.3287187
Kurtosis	65.749162
Mean	0.18472566
Median Absolute Deviation (MAD)	0
Skewness	3.1466823
Sum	71644
Variance	0.18504976
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	322149	83.1%
1	59982	15.5%
2	5542	1.4%
3	139	< 0.1%
4	17	< 0.1%
5	6	< 0.1%
30	1	< 0.1%
10	1	< 0.1%
9	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	322149	83.1%
1	59982	15.5%
2	5542	1.4%
3	139	< 0.1%
4	17	< 0.1%
5	6	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
30	1	< 0.1%
10	1	< 0.1%
9	1	< 0.1%
8	1	< 0.1%
6	1	< 0.1%
5	6	< 0.1%
4	17	< 0.1%
3	139	< 0.1%
2	5542	1.4%
1	59982	15.5%

PASAMUERTO
Real number (ℝ)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0047700083

Minimum	0
Maximum	11
Zeros	386408
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.093508134
Coefficient of variation (CV)	19.603349
Kurtosis	2305.0477
Mean	0.0047700083
Median Absolute Deviation (MAD)	0
Skewness	36.220117
Sum	1850
Variance	0.0087437712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	386408	99.6%
1	1169	0.3%
2	189	< 0.1%
3	40	< 0.1%
4	18	< 0.1%
6	5	< 0.1%
5	4	< 0.1%
10	2	< 0.1%
7	2	< 0.1%
8	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	386408	99.6%
1	1169	0.3%
2	189	< 0.1%
3	40	< 0.1%
4	18	< 0.1%
5	4	< 0.1%
6	5	< 0.1%
7	2	< 0.1%
8	2	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
10	2	< 0.1%
8	2	< 0.1%
7	2	< 0.1%
6	5	< 0.1%
5	4	< 0.1%
4	18	< 0.1%
3	40	< 0.1%
2	189	< 0.1%
1	1169	0.3%

PASAHERIDO
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.17838284

Minimum	0
Maximum	57
Zeros	342606
Zeros (%)	88.3%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	57
Range	57
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.64312653
Coefficient of variation (CV)	3.6053162
Kurtosis	464.54866
Mean	0.17838284
Median Absolute Deviation (MAD)	0
Skewness	11.437853
Sum	69184
Variance	0.41361174
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
0	342606	88.3%
1	31338	8.1%
2	8698	2.2%
3	2935	0.8%
4	1403	0.4%
5	393	0.1%
6	171	< 0.1%
7	93	< 0.1%
8	60	< 0.1%
10	42	< 0.1%
Other values (22)	101	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	342606	88.3%
1	31338	8.1%
2	8698	2.2%
3	2935	0.8%
4	1403	0.4%
5	393	0.1%
6	171	< 0.1%
7	93	< 0.1%
8	60	< 0.1%
9	32	< 0.1%

Value	Count	Frequency (%)
57	1	< 0.1%
49	1	< 0.1%
43	1	< 0.1%
37	2	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
24	2	< 0.1%
23	1	< 0.1%
22	1	< 0.1%

PEATMUERTO
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	386342
1	1477
2	18
3	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	387840
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	386342	99.6%
1	1477	0.4%
2	18	< 0.1%
3	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	386342	99.6%
1	1477	0.4%
2	18	< 0.1%
3	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	386342	99.6%
1	1477	0.4%
2	18	< 0.1%
3	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	387840	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	386342	99.6%
1	1477	0.4%
2	18	< 0.1%
3	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	387840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	386342	99.6%
1	1477	0.4%
2	18	< 0.1%
3	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	386342	99.6%
1	1477	0.4%
2	18	< 0.1%
3	3	< 0.1%

PEATHERIDO
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.060622937

Minimum	0
Maximum	10
Zeros	365679
Zeros (%)	94.3%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.25672021
Coefficient of variation (CV)	4.2347043
Kurtosis	47.748743
Mean	0.060622937
Median Absolute Deviation (MAD)	0
Skewness	5.1382863
Sum	23512
Variance	0.065905269
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	365679	94.3%
1	21036	5.4%
2	971	0.3%
3	116	< 0.1%
4	24	< 0.1%
5	9	< 0.1%
10	3	< 0.1%
7	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	365679	94.3%
1	21036	5.4%
2	971	0.3%
3	116	< 0.1%
4	24	< 0.1%
5	9	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
10	3	< 0.1%
8	1	< 0.1%
7	1	< 0.1%
5	9	< 0.1%
4	24	< 0.1%
3	116	< 0.1%
2	971	0.3%
1	21036	5.4%
0	365679	94.3%

CICLMUERTO
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	387325
1	512
2	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	387840
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	387325	99.9%
1	512	0.1%
2	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	387325	99.9%
1	512	0.1%
2	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	387325	99.9%
1	512	0.1%
2	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	387840	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	387325	99.9%
1	512	0.1%
2	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	387840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	387325	99.9%
1	512	0.1%
2	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	387325	99.9%
1	512	0.1%
2	3	< 0.1%

CICLHERIDO
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	379844
1	7902
2	91
3	2
-1	1

Length

Max length	2
Median length	1
Mean length	1.0000026
Min length	1

Characters and Unicode

Total characters	387841
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	379844	97.9%
1	7902	2.0%
2	91	< 0.1%
3	2	< 0.1%
-1	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	379844	97.9%
1	7903	2.0%
2	91	< 0.1%
3	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	379844	97.9%
1	7903	2.0%
2	91	< 0.1%
3	2	< 0.1%
-	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	387840	> 99.9%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	379844	97.9%
1	7903	2.0%
2	91	< 0.1%
3	2	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	387841	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	379844	97.9%
1	7903	2.0%
2	91	< 0.1%
3	2	< 0.1%
-	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387841	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	379844	97.9%
1	7903	2.0%
2	91	< 0.1%
3	2	< 0.1%
-	1	< 0.1%

OTROMUERTO
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	387732
1	101
2	7

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	387840
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	387732	> 99.9%
1	101	< 0.1%
2	7	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	387732	> 99.9%
1	101	< 0.1%
2	7	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	387732	> 99.9%
1	101	< 0.1%
2	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	387840	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	387732	> 99.9%
1	101	< 0.1%
2	7	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	387840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	387732	> 99.9%
1	101	< 0.1%
2	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	387732	> 99.9%
1	101	< 0.1%
2	7	< 0.1%

OTROHERIDO
Real number (ℝ)

SKEWED
ZEROS

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0046462459

Minimum	0
Maximum	12
Zeros	386332
Zeros (%)	99.6%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	12
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.083183152
Coefficient of variation (CV)	17.903304
Kurtosis	2230.0438
Mean	0.0046462459
Median Absolute Deviation (MAD)	0
Skewness	31.449668
Sum	1802
Variance	0.0069194368
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0	386332	99.6%
1	1272	0.3%
2	207	0.1%
3	18	< 0.1%
4	7	< 0.1%
12	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
10	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	386332	99.6%
1	1272	0.3%
2	207	0.1%
3	18	< 0.1%
4	7	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
10	1	< 0.1%
12	1	< 0.1%

Value	Count	Frequency (%)
12	1	< 0.1%
10	1	< 0.1%
7	1	< 0.1%
5	1	< 0.1%
4	7	< 0.1%
3	18	< 0.1%
2	207	0.1%
1	1272	0.3%
0	386332	99.6%

NEMUERTO
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	387840

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	387840
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	387840	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	387840	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	387840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	387840	100.0%

NEHERIDO
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	387840

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	387840
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	387840	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	387840	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	387840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	387840	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	387840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	387840	100.0%

Total_Muertos
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.016988965

Minimum	0
Maximum	11
Zeros	382142
Zeros (%)	98.5%
Negative	0
Negative (%)	0.0%
Memory size	3.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.15544209
Coefficient of variation (CV)	9.1495915
Kurtosis	424.21875
Mean	0.016988965
Median Absolute Deviation (MAD)	0
Skewness	14.899592
Sum	6589
Variance	0.024162242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	382142	98.5%
1	5088	1.3%
2	455	0.1%
3	95	< 0.1%
4	31	< 0.1%
5	13	< 0.1%
6	8	< 0.1%
8	3	< 0.1%
10	2	< 0.1%
7	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	382142	98.5%
1	5088	1.3%
2	455	0.1%
3	95	< 0.1%
4	31	< 0.1%
5	13	< 0.1%
6	8	< 0.1%
7	2	< 0.1%
8	3	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
10	2	< 0.1%
8	3	< 0.1%
7	2	< 0.1%
6	8	< 0.1%
5	13	< 0.1%
4	31	< 0.1%
3	95	< 0.1%
2	455	0.1%
1	5088	1.3%

Total_Heridos
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.44923422

Minimum	-1
Maximum	58
Zeros	265447
Zeros (%)	68.4%
Negative	1
Negative (%)	< 0.1%
Memory size	3.0 MiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	58
Range	59
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.86643204
Coefficient of variation (CV)	1.9286866
Kurtosis	153.56822
Mean	0.44923422
Median Absolute Deviation (MAD)	0
Skewness	5.8244887
Sum	174231
Variance	0.75070447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
0	265447	68.4%
1	90283	23.3%
2	21363	5.5%
3	6217	1.6%
4	2588	0.7%
5	1091	0.3%
6	400	0.1%
7	171	< 0.1%
8	88	< 0.1%
10	51	< 0.1%
Other values (23)	141	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	1	< 0.1%
0	265447	68.4%
1	90283	23.3%
2	21363	5.5%
3	6217	1.6%
4	2588	0.7%
5	1091	0.3%
6	400	0.1%
7	171	< 0.1%
8	88	< 0.1%

Value	Count	Frequency (%)
58	1	< 0.1%
50	1	< 0.1%
44	1	< 0.1%
37	2	< 0.1%
30	2	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
26	1	< 0.1%
24	1	< 0.1%
23	2	< 0.1%

Municipio_Nombre
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	72
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

Hermosillo	96495
Cajeme	74650
San Luis Río Colorado	45061
Guaymas	30280
Nogales	28059
Other values (67)	113295

Length

Max length	29
Median length	24
Mean length	9.8538727
Min length	4

Characters and Unicode

Total characters	3821726
Distinct characters	51
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Alamos
2nd row	Altar
3rd row	Altar
4th row	Altar
5th row	Baviácora

Common Values

Value	Count	Frequency (%)
Hermosillo	96495	24.9%
Cajeme	74650	19.2%
San Luis Río Colorado	45061	11.6%
Guaymas	30280	7.8%
Nogales	28059	7.2%
Caborca	27470	7.1%
Puerto Peñasco	14564	3.8%
Navojoa	14214	3.7%
Agua Prieta	7105	1.8%
Empalme	6886	1.8%
Other values (62)	43056	11.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
hermosillo	96495	17.0%
cajeme	74650	13.2%
san	47177	8.3%
río	46533	8.2%
luis	45061	8.0%
colorado	45061	8.0%
guaymas	30280	5.4%
nogales	28059	5.0%
caborca	27470	4.9%
puerto	14564	2.6%
Other values (83)	110625	19.5%

Most occurring characters

Value	Count	Frequency (%)
o	518109	13.6%
a	448024	11.7%
e	345034	9.0%
l	288824	7.6%
m	225413	5.9%
s	225116	5.9%
r	213560	5.6%
	178135	4.7%
i	164429	4.3%
C	156348	4.1%
Other values (41)	1058734	27.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3080787	80.6%
Uppercase Letter	562804	14.7%
Space Separator	178135	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	518109	16.8%
a	448024	14.5%
e	345034	11.2%
l	288824	9.4%
m	225413	7.3%
s	225116	7.3%
r	213560	6.9%
i	164429	5.3%
u	114998	3.7%
j	94300	3.1%
Other values (18)	442980	14.4%

Uppercase Letter

Value	Count	Frequency (%)
C	156348	27.8%
H	100675	17.9%
S	49607	8.8%
R	47114	8.4%
N	45452	8.1%
L	45219	8.0%
P	38923	6.9%
G	34665	6.2%
E	13709	2.4%
A	11317	2.0%
Other values (12)	19775	3.5%

Space Separator

Value	Count	Frequency (%)
	178135	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3643591	95.3%
Common	178135	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	518109	14.2%
a	448024	12.3%
e	345034	9.5%
l	288824	7.9%
m	225413	6.2%
s	225116	6.2%
r	213560	5.9%
i	164429	4.5%
C	156348	4.3%
u	114998	3.2%
Other values (40)	943736	25.9%

Common

Value	Count	Frequency (%)
	178135	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3748542	98.1%
None	73184	1.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	518109	13.8%
a	448024	12.0%
e	345034	9.2%
l	288824	7.7%
m	225413	6.0%
s	225116	6.0%
r	213560	5.7%
	178135	4.8%
i	164429	4.4%
C	156348	4.2%
Other values (35)	985550	26.3%

None

Value	Count	Frequency (%)
í	51248	70.0%
ñ	14564	19.9%
á	6401	8.7%
ó	522	0.7%
é	343	0.5%
ú	106	0.1%

Fecha_Formated
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	341656
Distinct (%)	88.1%
Missing	0
Missing (%)	0.0%
Memory size	3.0 MiB

0	433
2021-02-28 23:00:00	43
2020-04-28 23:00:00	42
2020-08-28 23:00:00	42
2021-08-28 23:00:00	41
Other values (341651)	387239

Length

Max length	19
Median length	19
Mean length	18.979904
Min length	1

Characters and Unicode

Total characters	7361166
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	305758 ?
Unique (%)	78.8%

Sample

1st row	1997-01-17 18:00:00
2nd row	1997-01-15 17:00:00
3rd row	1997-01-30 19:00:00
4th row	1997-01-14 03:00:00
5th row	1997-01-06 09:00:00

Common Values

Value	Count	Frequency (%)
0	433	0.1%
2021-02-28 23:00:00	43	< 0.1%
2020-04-28 23:00:00	42	< 0.1%
2020-08-28 23:00:00	42	< 0.1%
2021-08-28 23:00:00	41	< 0.1%
2020-03-28 23:00:00	41	< 0.1%
2019-03-28 23:00:00	40	< 0.1%
2019-02-28 23:00:00	40	< 0.1%
2021-06-28 23:00:00	40	< 0.1%
2021-01-28 23:00:00	40	< 0.1%
Other values (341646)	387038	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
18:00:00	5174	0.7%
14:00:00	4886	0.6%
19:00:00	4718	0.6%
17:00:00	4655	0.6%
20:00:00	4462	0.6%
15:00:00	4396	0.6%
16:00:00	4394	0.6%
13:00:00	4218	0.5%
18:30:00	4068	0.5%
23:00:00	4049	0.5%
Other values (10562)	730227	94.2%

Most occurring characters

Value	Count	Frequency (%)
0	2307578	31.3%
1	895342	12.2%
2	802541	10.9%
-	774814	10.5%
:	774814	10.5%
	387407	5.3%
5	255585	3.5%
9	254283	3.5%
3	249699	3.4%
4	192046	2.6%
Other values (3)	467057	6.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5424131	73.7%
Dash Punctuation	774814	10.5%
Other Punctuation	774814	10.5%
Space Separator	387407	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2307578	42.5%
1	895342	16.5%
2	802541	14.8%
5	255585	4.7%
9	254283	4.7%
3	249699	4.6%
4	192046	3.5%
8	167446	3.1%
7	160745	3.0%
6	138866	2.6%

Dash Punctuation

Value	Count	Frequency (%)
-	774814	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	774814	100.0%

Space Separator

Value	Count	Frequency (%)
	387407	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7361166	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2307578	31.3%
1	895342	12.2%
2	802541	10.9%
-	774814	10.5%
:	774814	10.5%
	387407	5.3%
5	255585	3.5%
9	254283	3.5%
3	249699	3.4%
4	192046	2.6%
Other values (3)	467057	6.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7361166	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2307578	31.3%
1	895342	12.2%
2	802541	10.9%
-	774814	10.5%
:	774814	10.5%
	387407	5.3%
5	255585	3.5%
9	254283	3.5%
3	249699	3.4%
4	192046	2.6%
Other values (3)	467057	6.3%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Unnamed: 0	ID_MUNICIPIO	ANIO	MES	ID_HORA	ID_DIA	DIASEMANA	URBANA	SUBURBANA	TIPACCID	CAUSAACCI	CAPAROD	SEXO	ALIENTO	CINTURON	ID_EDAD	PASAHERIDO	Total_Heridos	Municipio_Nombre	Fecha_Formated
0	207539	3	1997	1	18	17	Viernes	Sin accidente en esta zona	Accidente en carretera estatal	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	Se ignora	Se ignora	18	0	0	Alamos	1997-01-17 18:00:00
1	207540	4	1997	1	17	15	Miércoles	Sin accidente en esta zona	Accidente en camino rural	Volcadura	Conductor	No Pavimentada	Se fugó	Se ignora	Se ignora	0	0	0	Altar	1997-01-15 17:00:00
2	207541	4	1997	1	19	30	Jueves	Sin accidente en esta zona	Accidente en camino rural	Colisión con animal	Otra	No Pavimentada	Hombre	No	Se ignora	18	0	0	Altar	1997-01-30 19:00:00
3	207542	4	1997	1	3	14	Martes	Accidente en no intersección	Sin accidente en esta zona	Colisión con objeto fijo	Conductor	No Pavimentada	Se fugó	Se ignora	Se ignora	0	0	0	Altar	1997-01-14 03:00:00
4	207543	14	1997	1	9	6	Lunes	Accidente en intersección	Sin accidente en esta zona	Colisión con objeto fijo	Conductor	No Pavimentada	Hombre	Se ignora	Se ignora	18	0	0	Baviácora	1997-01-06 09:00:00
5	207544	14	1997	1	17	25	Sábado	Accidente en intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	Se ignora	Se ignora	18	1	1	Baviácora	1997-01-25 17:30:00
6	207545	17	1997	1	16	26	Domingo	Accidente en no intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	Se ignora	Se ignora	18	0	0	Caborca	1997-01-26 16:30:00
7	207546	17	1997	1	16	27	Lunes	Accidente en no intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	Se ignora	Se ignora	18	0	0	Caborca	1997-01-27 16:30:00
8	207547	17	1997	1	16	28	Martes	Accidente en no intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	Se ignora	Se ignora	18	0	0	Caborca	1997-01-28 16:50:00
9	207548	17	1997	1	19	29	Miércoles	Accidente en no intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	Se ignora	Se ignora	18	0	0	Caborca	1997-01-29 19:20:00

	Unnamed: 0	ID_MUNICIPIO	ANIO	MES	ID_HORA	ID_DIA	DIASEMANA	URBANA	SUBURBANA	TIPACCID	CAUSAACCI	CAPAROD	SEXO	ALIENTO	CINTURON	ID_EDAD	CONDHERIDO	PASAHERIDO	Total_Heridos	Municipio_Nombre	Fecha_Formated
387830	9511216	72	2021	11	13	26	Viernes	Accidente en intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	No	No	20	0	0	0	San Ignacio Río Muerto	2021-11-26 13:15:00
387831	9511217	72	2021	11	19	29	Lunes	Accidente en intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	No	Se ignora	53	0	0	0	San Ignacio Río Muerto	2021-11-29 19:12:00
387832	9511218	72	2021	11	22	29	Lunes	Accidente en intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	No	No	29	0	0	0	San Ignacio Río Muerto	2021-11-29 22:22:00
387833	9511219	72	2021	11	23	29	Lunes	Accidente en intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	No	No	30	0	0	0	San Ignacio Río Muerto	2021-11-29 23:47:00
387834	9511220	72	2021	12	17	3	Viernes	Accidente en intersección	Sin accidente en esta zona	Colisión con animal	Mala condición del camino	No Pavimentada	Mujer	No	No	43	1	1	2	San Ignacio Río Muerto	2021-12-03 17:42:00
387835	9511221	72	2021	12	2	5	Domingo	Accidente en intersección	Sin accidente en esta zona	Colisión con motocicleta	Conductor	No Pavimentada	Hombre	No	No	20	1	1	2	San Ignacio Río Muerto	2021-12-05 02:35:00
387836	9511222	72	2021	12	21	12	Domingo	Accidente en intersección	Sin accidente en esta zona	Colisión con vehículo automotor	Conductor	Pavimentada	Hombre	No	No	21	1	0	1	San Ignacio Río Muerto	2021-12-12 21:39:00
387837	9511223	72	2021	12	15	25	Sábado	Sin accidente en esta zona	Accidente en camino rural	Colisión con objeto fijo	Conductor	Pavimentada	Hombre	No	No	29	1	0	1	San Ignacio Río Muerto	2021-12-25 15:55:00
387838	9511224	72	2021	12	8	26	Domingo	Sin accidente en esta zona	Accidente en camino rural	Volcadura	Conductor	Pavimentada	Hombre	No	No	28	1	0	1	San Ignacio Río Muerto	2021-12-26 08:59:00
387839	9511225	72	2021	12	17	26	Domingo	Sin accidente en esta zona	Accidente en camino rural	Salida del camino	Conductor	Pavimentada	Hombre	No	No	42	1	1	2	San Ignacio Río Muerto	2021-12-26 17:21:00

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts